{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["D5 GR A","D5 GR B","D5 GR C"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"D5 GR A","index":0,"n_rows":328,"n_cols":22,"rows_kept":328,"cut":false,"hidden":false,"merged":[[29,1,29,10],[0,2,0,5],[0,8,0,9],[4,2,4,5],[5,8,5,9],[8,2,8,5],[12,2,12,5],[12,6,12,9],[10,6,10,9],[13,6,13,7],[16,2,16,5],[26,1,26,10],[27,1,27,10],[28,1,28,10]]}
[1,"VERON 3","Match 1: à  - Dimanche 07 Septembre à 8H30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"ST MARTIN DU TERTRE 4",{"$f":"$B$1","v":"VERON 3"},{"$f":"$B$2","v":"ST MARTIN DU TERTRE 4"},null,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",36-E2)))","v":""},null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(Q2=\"\",\"\",IF(Q2=\"F\",0,IF(Q2=18,2,IF(Q2>18,3,1))))","v":""},null,null,{"$f":"IF(Q2=\"G\",19,IF(Q2=\"\",0,Q2))","v":0},{"$f":"IF(Q2=\"\",\"\",IF(U2=36,36,IF(U2=0,-36,IF(U2=19,19,IF(U2=\"f\",-19,U2-(36-U2))))))","v":""}]
[3," APPOIGNY 4",{"$f":"$B$3","v":" APPOIGNY 4"},{"$f":"$B$4","v":" GRON 1"},null,{"$f":"IF(E3=\"\",\"\",IF(E3=\"F\",\"G\",IF(E3=\"G\",\"F\",36-E3)))","v":""},null,null,null,null,null,null,null,null,null,0,null,"",null,null,{"$f":"IF(Q3=\"G\",19,IF(Q3=\"\",0,Q3))","v":0},{"$f":"IF(Q3=\"\",\"\",IF(U3=36,36,IF(U3=0,-36,IF(U3=19,19,IF(U3=\"f\",-19,U3-(36-U3))))))","v":""}]
[4," GRON 1",{"$f":"$B$5","v":"MIGENNES 6"},{"$f":"$B$6","v":"PONT / YONNE 1"},null,{"$f":"IF(E4=\"\",\"\",IF(E4=\"F\",\"G\",IF(E4=\"G\",\"F\",36-E4)))","v":""},null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[5,"MIGENNES 6","Match 2: à  - Dimanche 07 Septembre à 14h00",null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[6,"PONT / YONNE 1",{"$f":"$B$3","v":" APPOIGNY 4"},{"$f":"$B$1","v":"VERON 3"},null,{"$f":"IF(E6=\"\",\"\",IF(E6=\"F\",\"G\",IF(E6=\"G\",\"F\",36-E6)))","v":""},null,null,null,null,null,null,null,null,null,0,"","",{"$f":"SUM(R2:R6)","v":0},{"$f":"SUM(V2:V6)","v":0},0,""]
[null,null,{"$f":"$B$2","v":"ST MARTIN DU TERTRE 4"},{"$f":"$B$5","v":"MIGENNES 6"},null,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",36-E7)))","v":""},null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,{"$f":"$B$4","v":" GRON 1"},{"$f":"$B$6","v":"PONT / YONNE 1"},null,{"$f":"IF(E8=\"\",\"\",IF(E8=\"F\",\"G\",IF(E8=\"G\",\"F\",36-E8)))","v":""},null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,"Match 3: à  - Dimanche 28 Septembre à 8h30",null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,{"$f":"$B$4","v":" GRON 1"},{"$f":"$B$1","v":"VERON 3"},null,{"$f":"IF(E10=\"\",\"\",IF(E10=\"F\",\"G\",IF(E10=\"G\",\"F\",36-E10)))","v":""},null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
["Rappel:",null,{"$f":"$B$6","v":"PONT / YONNE 1"},{"$f":"$B$2","v":"ST MARTIN DU TERTRE 4"},null,{"$f":"IF(E11=\"\",\"\",IF(E11=\"F\",\"G\",IF(E11=\"G\",\"F\",36-E11)))","v":""},null,null,null,null,null,null,null,null,null,0,"","",{"$f":"SUM(R7:R11)","v":0},{"$f":"SUM(V7:V11)","v":0},0,""]
["Seules les Cases Blanches",null,{"$f":"$B$5","v":"MIGENNES 6"},{"$f":"$B$3","v":" APPOIGNY 4"},null,{"$f":"IF(E12=\"\",\"\",IF(E12=\"F\",\"G\",IF(E12=\"G\",\"F\",36-E12)))","v":""},null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
["sont à remplir",null,"Match 4:  à  - Dimanche 28 Septembre à 14H00",null,null,null,"Classement",null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,{"$f":"$B$1","v":"VERON 3"},{"$f":"$B$5","v":"MIGENNES 6"},null,{"$f":"IF(E14=\"\",\"\",IF(E14=\"F\",\"G\",IF(E14=\"G\",\"F\",36-E14)))","v":""},null,null,"Pts","+/-",null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,{"$f":"$B$2","v":"ST MARTIN DU TERTRE 4"},{"$f":"$B$4","v":" GRON 1"},null,{"$f":"IF(E15=\"\",\"\",IF(E15=\"F\",\"G\",IF(E15=\"G\",\"F\",36-E15)))","v":""},1,"VERON 3",0,0,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,{"$f":"$B$3","v":" APPOIGNY 4"},{"$f":"$B$6","v":"PONT / YONNE 1"},null,{"$f":"IF(E16=\"\",\"\",IF(E16=\"F\",\"G\",IF(E16=\"G\",\"F\",36-E16)))","v":""},2,"ST MARTIN DU TERTRE 4",0,0,null,null,null,null,null,0,null,"",{"$f":"SUM(R12:R16)","v":0},{"$f":"SUM(V12:V16)","v":0},0,""]
[null,null,"Match 5: à  - Dimanche 05 Octobre à 14H00",null,null,null,3," APPOIGNY 4",0,0,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,{"$f":"$B$6","v":"PONT / YONNE 1"},{"$f":"$B$1","v":"VERON 3"},null,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":""},4," GRON 1",0,0,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,{"$f":"$B$2","v":"ST MARTIN DU TERTRE 4"},{"$f":"$B$3","v":" APPOIGNY 4"},null,{"$f":"IF(E19=\"\",\"\",IF(E19=\"F\",\"G\",IF(E19=\"G\",\"F\",36-E19)))","v":""},5,"MIGENNES 6",0,0,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,{"$f":"$B$5","v":"MIGENNES 6"},{"$f":"$B$4","v":" GRON 1"},null,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",36-E20)))","v":""},6,"PONT / YONNE 1",0,0,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",{"$f":"SUM(R17:R21)","v":0},{"$f":"SUM(V17:V21)","v":0},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",{"$f":"SUM(R22:R26)","v":0},{"$f":"SUM(V22:V26)","v":0},0,""]
[null,"FÉDÉRATION FRANÇAISE DE PÉTANQUE ET JEU PROVENÇAL",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,"AGRÉÉE PAR LE MINISTÈRE DE LA JEUNESSE ET  DES SPORTS ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"",null,null,0,""]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,"Championnat Départemental des Clubs 2025 Open Division 5 Groupe A",null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","",{"$f":"SUM(R27:R31)","v":0},{"$f":"SUM(V27:V31)","v":0},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U58=0,\"\",IF(U58=19,\"\",U58-(36-U58)))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1) Remplir la liste des Clubs composant le Groupe (Colonne B1 à B14)"]
[]
[null,"2) Le calendrier se fait automatiquement"]
[]
[null,"3) Pour chaque rencontre: mettre uniquemment le score de la premiere équipe (Case Blanche,la rouge sera remplie automatiquement)"]
[]
[null,"4) Le score de l'adversaire se mettra automatiquement"]
[]
[null,"Exemple:"]
[null,"L' équipe 1 Gagne par 32 à 4 : il faut mettre 32 pour le score de L'équipe 1 contre l'équipe 2 (4 sera automatique)"]
[null,null,"Essayez : Tapez 32 ici"]
[]
[null,null,{"$f":"$B$1","v":"VERON 3"},{"$f":"$B$2","v":"ST MARTIN DU TERTRE 4"},null,{"$f":"IF(E306=\"\",\"\",IF(E306=\"F\",\"G\",IF(E306=\"G\",\"F\",36-E306)))","v":""}]
[null,null,{"$f":"$B$3","v":" APPOIGNY 4"},"Equipe 4",null,{"$f":"IF(E307=\"\",\"\",IF(E307=\"F\",\"G\",IF(E307=\"G\",\"F\",36-E307)))","v":""}]
[]
[null,null,"Essayez : Tapez 17 ici"]
[]
[null,"L' équipe 4 Gagne par 19 à 17 : il faut mettre 17 pour le score de L'équipe 3 contre l'équipe 2 (19  sera automatique)"]
[]
[null,"5) Pour le Forfait : Mettre F si Premiere equipe Forfait sinon mettre G"]
[]
[null,"Exemple:"]
[null,"L' équipe 1 est forfait : il faut mettre un F pour le score de L'équipe 1 contre l'équipe 2 (G est automatique)"]
[null,null,"Essayez : Tapez un F ici"]
[]
[null,null,{"$f":"$B$1","v":"VERON 3"},{"$f":"$B$2","v":"ST MARTIN DU TERTRE 4"},null,{"$f":"IF(E319=\"\",\"\",IF(E319=\"F\",\"G\",IF(E319=\"G\",\"F\",36-E319)))","v":""}]
[null,null,{"$f":"$B$3","v":" APPOIGNY 4"},"Equipe 4",null,{"$f":"IF(E320=\"\",\"\",IF(E320=\"F\",\"G\",IF(E320=\"G\",\"F\",36-E320)))","v":""}]
[]
[null,null,"Essayez : Tapez un G ici"]
[null,"L' équipe 4 est forfait : il faut mettre un G pour le score de L'équipe 3 contre l'équipe 4 (F est automatique)"]
[]
[]
[null,"En cas de Forfait : le score attribué est 19 à 0"]
[]
[null,"Ne pas oublier d'appuyer sur le bouton Maj Classement sous le Classement"]

{"sheet":"D5 GR B","index":1,"n_rows":328,"n_cols":23,"rows_kept":328,"cut":false,"hidden":false,"merged":[[10,6,10,9],[0,2,0,5],[0,8,0,9],[4,2,4,5],[5,8,5,9],[8,2,8,5],[28,1,28,10],[29,1,29,10],[12,2,12,5],[12,6,12,9],[13,6,13,7],[16,2,16,5],[26,1,26,10],[27,1,27,10]]}
[1,"CHARBUY 3","Match 1: à  - Dimanche 07 Septembre à 8H30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"MIGENNES 5",{"$f":"$B$1","v":"CHARBUY 3"},{"$f":"$B$2","v":"MIGENNES 5"},null,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",36-E2)))","v":""},null,null,null,null,null,null,null,null,null,"BLENEAU 1",null,{"$f":"IF(Q2=\"\",\"\",IF(Q2=\"F\",0,IF(Q2=18,2,IF(Q2>18,3,1))))","v":""},null,null,{"$f":"IF(Q2=\"G\",19,IF(Q2=\"\",0,Q2))","v":0},{"$f":"IF(Q2=\"\",\"\",IF(U2=36,36,IF(U2=0,-36,IF(U2=19,19,IF(U2=\"f\",-19,U2-(36-U2))))))","v":""}]
[3," CHEU 2",{"$f":"$B$4","v":"GRON 2"},{"$f":"$B$3","v":" CHEU 2"},null,{"$f":"IF(E3=\"\",\"\",IF(E3=\"F\",\"G\",IF(E3=\"G\",\"F\",36-E3)))","v":""},null,null,null,null,null,null,null,null,null,"BLENEAU 1","","",null,null,{"$f":"IF(Q3=\"G\",19,IF(Q3=\"\",0,Q3))","v":0},{"$f":"IF(Q3=\"\",\"\",IF(U3=36,36,IF(U3=0,-36,IF(U3=19,19,IF(U3=\"f\",-19,U3-(36-U3))))))","v":""}]
[4,"GRON 2",{"$f":"$B$5","v":" LIGNY LE CHATEL 1"},{"$f":"$B$6","v":"AILLANT 3"},null,{"$f":"IF(E4=\"\",\"\",IF(E4=\"F\",\"G\",IF(E4=\"G\",\"F\",36-E4)))","v":""},null,null,null,null,null,null,null,null,null,"BLENEAU 1","","",null,null,0,""]
[5," LIGNY LE CHATEL 1","Match 2: à  - Dimanche 07 Septembre à 14h00",null,null,null,null,null,null,null,null,null,null,null,null,"BLENEAU 1",null,"",null,null,0,""]
[6,"AILLANT 3",{"$f":"$B$3","v":" CHEU 2"},{"$f":"$B$1","v":"CHARBUY 3"},null,{"$f":"IF(E6=\"\",\"\",IF(E6=\"F\",\"G\",IF(E6=\"G\",\"F\",36-E6)))","v":""},null,null,null,null,null,null,null,null,null,"BLENEAU 1","","",{"$f":"SUM(R2:R6)","v":0},{"$f":"SUM(V2:V6)","v":0},0,""]
[null,null,{"$f":"$B$2","v":"MIGENNES 5"},{"$f":"$B$5","v":" LIGNY LE CHATEL 1"},null,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",36-E7)))","v":""},null,null,null,null,null,null,null,null,null,"CHARBUY 4","","",null,null,0,""]
[null,null,{"$f":"$B$6","v":"AILLANT 3"},{"$f":"$B$4","v":"GRON 2"},null,{"$f":"IF(E8=\"\",\"\",IF(E8=\"F\",\"G\",IF(E8=\"G\",\"F\",36-E8)))","v":""},null,null,null,null,null,null,null,null,null,"CHARBUY 4",null,"",null,null,0,""]
[null,null,"Match 3: à  - Dimanche 28 Septembre à 8h30",null,null,null,null,null,null,null,null,null,null,null,null,"CHARBUY 4","","",null,null,0,""]
[null,null,{"$f":"$B$4","v":"GRON 2"},{"$f":"$B$1","v":"CHARBUY 3"},null,{"$f":"IF(E10=\"\",\"\",IF(E10=\"F\",\"G\",IF(E10=\"G\",\"F\",36-E10)))","v":""},null,null,null,null,null,null,null,null,null,"CHARBUY 4",null,"",null,null,0,""]
["Rappel:",null,{"$f":"$B$6","v":"AILLANT 3"},{"$f":"$B$2","v":"MIGENNES 5"},null,{"$f":"IF(E11=\"\",\"\",IF(E11=\"F\",\"G\",IF(E11=\"G\",\"F\",36-E11)))","v":""},null,null,null,null,null,null,null,null,null,"CHARBUY 4",null,"",{"$f":"SUM(R7:R11)","v":0},{"$f":"SUM(V7:V11)","v":0},0,""]
["Seules les Cases Blanches",null,{"$f":"$B$5","v":" LIGNY LE CHATEL 1"},{"$f":"$B$3","v":" CHEU 2"},null,{"$f":"IF(E12=\"\",\"\",IF(E12=\"F\",\"G\",IF(E12=\"G\",\"F\",36-E12)))","v":""},null,null,null,null,null,null,null,null,null,"MIGENNES 4",null,"",null,null,0,""]
["sont à remplir",null,"Match 4:  à  - Dimanche 28 Septembre à 14H00",null,null,null,"Classement",null,null,null,null,null,null,null,null,"MIGENNES 4","","",null,null,0,""]
[null,null,{"$f":"$B$1","v":"CHARBUY 3"},{"$f":"$B$5","v":" LIGNY LE CHATEL 1"},null,{"$f":"IF(E14=\"\",\"\",IF(E14=\"F\",\"G\",IF(E14=\"G\",\"F\",36-E14)))","v":""},null,null,"Pts","+/-",null,null,null,null,null,"MIGENNES 4",null,"",null,null,0,""," "]
[null,null,{"$f":"$B$2","v":"MIGENNES 5"},{"$f":"$B$4","v":"GRON 2"},null,{"$f":"IF(E15=\"\",\"\",IF(E15=\"F\",\"G\",IF(E15=\"G\",\"F\",36-E15)))","v":""},1,"CHARBUY 3",0,0,null,null,null,null,null,"MIGENNES 4","","",null,null,0,""]
[null,null,{"$f":"$B$3","v":" CHEU 2"},{"$f":"$B$6","v":"AILLANT 3"},null,{"$f":"IF(E16=\"\",\"\",IF(E16=\"F\",\"G\",IF(E16=\"G\",\"F\",36-E16)))","v":""},2,"MIGENNES 5",0,0,null,null,null,null,null,"MIGENNES 4",null,"",{"$f":"SUM(R12:R16)","v":0},{"$f":"SUM(V12:V16)","v":0},0,""]
[null,null,"Match 5: à  - Dimanche 05 Octobre à 14H00",null,null,null,3," CHEU 2",0,0,null,null,null,null,null,"MONETEAU 3","","",null,null,0,""]
[null,null,{"$f":"$B$6","v":"AILLANT 3"},{"$f":"$B$1","v":"CHARBUY 3"},null,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":""},4,"GRON 2",0,0,null,null,null,null,null,"MONETEAU 3",null,"",null,null,0,""]
[null,null,{"$f":"$B$2","v":"MIGENNES 5"},{"$f":"$B$3","v":" CHEU 2"},null,{"$f":"IF(E19=\"\",\"\",IF(E19=\"F\",\"G\",IF(E19=\"G\",\"F\",36-E19)))","v":""},5," LIGNY LE CHATEL 1",0,0,null,null,null,null,null,"MONETEAU 3","","",null,null,0,""]
[null,null,{"$f":"$B$4","v":"GRON 2"},{"$f":"$B$5","v":" LIGNY LE CHATEL 1"},null,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",36-E20)))","v":""},6,"AILLANT 3",0,0,null,null,null,null,null,"MONETEAU 3",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONETEAU 3","","",{"$f":"SUM(R17:R21)","v":0},{"$f":"SUM(V17:V21)","v":0},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST PÈRE / VEZELAY 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST PÈRE / VEZELAY 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST PÈRE / VEZELAY 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST PÈRE / VEZELAY 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST PÈRE / VEZELAY 1","","",{"$f":"SUM(R22:R26)","v":0},{"$f":"SUM(V22:V26)","v":0},0,""]
[null,"FÉDÉRATION FRANÇAISE DE PÉTANQUE ET JEU PROVENÇAL",null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3","","",null,null,0,""]
[null,"AGRÉÉE PAR LE MINISTÈRE DE LA JEUNESSE ET  DES SPORTS ",null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3",null,"",null,null,0,""]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3",null,"",null,null,0,""]
[null,"Championnat Départemental des Clubs 2025 Open Division 5 Groupe B",null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3",null,"",{"$f":"SUM(R27:R31)","v":0},{"$f":"SUM(V27:V31)","v":0},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U58=0,\"\",IF(U58=19,\"\",U58-(36-U58)))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1) Remplir la liste des Clubs composant le Groupe (Colonne B1 à B14)"]
[]
[null,"2) Le calendrier se fait automatiquement"]
[]
[null,"3) Pour chaque rencontre: mettre uniquemment le score de la premiere équipe (Case Blanche,la rouge sera remplie automatiquement)"]
[]
[null,"4) Le score de l'adversaire se mettra automatiquement"]
[]
[null,"Exemple:"]
[null,"L' équipe 1 Gagne par 32 à 4 : il faut mettre 32 pour le score de L'équipe 1 contre l'équipe 2 (4 sera automatique)"]
[null,null,"Essayez : Tapez 32 ici"]
[]
[null,null,{"$f":"$B$1","v":"CHARBUY 3"},{"$f":"$B$2","v":"MIGENNES 5"},null,{"$f":"IF(E306=\"\",\"\",IF(E306=\"F\",\"G\",IF(E306=\"G\",\"F\",36-E306)))","v":""}]
[null,null,{"$f":"$B$3","v":" CHEU 2"},"Equipe 4",null,{"$f":"IF(E307=\"\",\"\",IF(E307=\"F\",\"G\",IF(E307=\"G\",\"F\",36-E307)))","v":""}]
[]
[null,null,"Essayez : Tapez 17 ici"]
[]
[null,"L' équipe 4 Gagne par 19 à 17 : il faut mettre 17 pour le score de L'équipe 3 contre l'équipe 2 (19  sera automatique)"]
[]
[null,"5) Pour le Forfait : Mettre F si Premiere equipe Forfait sinon mettre G"]
[]
[null,"Exemple:"]
[null,"L' équipe 1 est forfait : il faut mettre un F pour le score de L'équipe 1 contre l'équipe 2 (G est automatique)"]
[null,null,"Essayez : Tapez un F ici"]
[]
[null,null,{"$f":"$B$1","v":"CHARBUY 3"},{"$f":"$B$2","v":"MIGENNES 5"},null,{"$f":"IF(E319=\"\",\"\",IF(E319=\"F\",\"G\",IF(E319=\"G\",\"F\",36-E319)))","v":""}]
[null,null,{"$f":"$B$3","v":" CHEU 2"},"Equipe 4",null,{"$f":"IF(E320=\"\",\"\",IF(E320=\"F\",\"G\",IF(E320=\"G\",\"F\",36-E320)))","v":""}]
[]
[null,null,"Essayez : Tapez un G ici"]
[null,"L' équipe 4 est forfait : il faut mettre un G pour le score de L'équipe 3 contre l'équipe 4 (F est automatique)"]
[]
[]
[null,"En cas de Forfait : le score attribué est 19 à 0"]
[]
[null,"Ne pas oublier d'appuyer sur le bouton Maj Classement sous le Classement"]

{"sheet":"D5 GR C","index":2,"n_rows":328,"n_cols":23,"rows_kept":328,"cut":false,"hidden":false,"merged":[[10,6,10,9],[0,2,0,5],[0,8,0,9],[4,2,4,5],[5,8,5,9],[8,2,8,5],[28,1,28,10],[29,1,29,10],[12,2,12,5],[12,6,12,9],[13,6,13,7],[16,2,16,5],[26,1,26,10],[27,1,27,10]]}
[1,"RAVIERES 4","Match 1: à  - Dimanche 07 Septembre à 8H30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pt","TPt","T+/-","+","-"]
[2,"MAILLY LA VILLE 1",{"$f":"$B$1","v":"RAVIERES 4"},{"$f":"$B$2","v":"MAILLY LA VILLE 1"},null,{"$f":"IF(E2=\"\",\"\",IF(E2=\"F\",\"G\",IF(E2=\"G\",\"F\",36-E2)))","v":""},null,null,null,null,null,null,null,null,null,"BLENEAU 1",null,{"$f":"IF(Q2=\"\",\"\",IF(Q2=\"F\",0,IF(Q2=18,2,IF(Q2>18,3,1))))","v":""},null,null,{"$f":"IF(Q2=\"G\",19,IF(Q2=\"\",0,Q2))","v":0},{"$f":"IF(Q2=\"\",\"\",IF(U2=36,36,IF(U2=0,-36,IF(U2=19,19,IF(U2=\"f\",-19,U2-(36-U2))))))","v":""}]
[3,"LAVAU 1",{"$f":"$B$4","v":"GIVRY 1"},{"$f":"$B$3","v":"LAVAU 1"},null,{"$f":"IF(E3=\"\",\"\",IF(E3=\"F\",\"G\",IF(E3=\"G\",\"F\",36-E3)))","v":""},null,null,null,null,null,null,null,null,null,"BLENEAU 1","","",null,null,{"$f":"IF(Q3=\"G\",19,IF(Q3=\"\",0,Q3))","v":0},{"$f":"IF(Q3=\"\",\"\",IF(U3=36,36,IF(U3=0,-36,IF(U3=19,19,IF(U3=\"f\",-19,U3-(36-U3))))))","v":""}]
[4,"GIVRY 1",{"$f":"$B$5","v":"ST PÈRE / VEZELAY 1"},{"$f":"$B$6","v":"TOUCY 1"},null,{"$f":"IF(E4=\"\",\"\",IF(E4=\"F\",\"G\",IF(E4=\"G\",\"F\",36-E4)))","v":""},null,null,null,null,null,null,null,null,null,"BLENEAU 1","","",null,null,0,""]
[5,"ST PÈRE / VEZELAY 1","Match 2: à  - Dimanche 07 Septembre à 14h00",null,null,null,null,null,null,null,null,null,null,null,null,"BLENEAU 1",null,"",null,null,0,""]
[6,"TOUCY 1",{"$f":"$B$3","v":"LAVAU 1"},{"$f":"$B$1","v":"RAVIERES 4"},null,{"$f":"IF(E6=\"\",\"\",IF(E6=\"F\",\"G\",IF(E6=\"G\",\"F\",36-E6)))","v":""},null,null,null,null,null,null,null,null,null,"BLENEAU 1","","",{"$f":"SUM(R2:R6)","v":0},{"$f":"SUM(V2:V6)","v":0},0,""]
[null,null,{"$f":"$B$2","v":"MAILLY LA VILLE 1"},{"$f":"$B$5","v":"ST PÈRE / VEZELAY 1"},null,{"$f":"IF(E7=\"\",\"\",IF(E7=\"F\",\"G\",IF(E7=\"G\",\"F\",36-E7)))","v":""},null,null,null,null,null,null,null,null,null,"CHARBUY 4","","",null,null,0,""]
[null,null,{"$f":"$B$6","v":"TOUCY 1"},{"$f":"$B$4","v":"GIVRY 1"},null,{"$f":"IF(E8=\"\",\"\",IF(E8=\"F\",\"G\",IF(E8=\"G\",\"F\",36-E8)))","v":""},null,null,null,null,null,null,null,null,null,"CHARBUY 4",null,"",null,null,0,""]
[null,null,"Match 3: à  - Dimanche 28 Septembre à 8h30",null,null,null,null,null,null,null,null,null,null,null,null,"CHARBUY 4","","",null,null,0,""]
[null,null,{"$f":"$B$4","v":"GIVRY 1"},{"$f":"$B$1","v":"RAVIERES 4"},null,{"$f":"IF(E10=\"\",\"\",IF(E10=\"F\",\"G\",IF(E10=\"G\",\"F\",36-E10)))","v":""},null,null,null,null,null,null,null,null,null,"CHARBUY 4",null,"",null,null,0,""]
["Rappel:",null,{"$f":"$B$6","v":"TOUCY 1"},{"$f":"$B$2","v":"MAILLY LA VILLE 1"},null,{"$f":"IF(E11=\"\",\"\",IF(E11=\"F\",\"G\",IF(E11=\"G\",\"F\",36-E11)))","v":""},null,null,null,null,null,null,null,null,null,"CHARBUY 4",null,"",{"$f":"SUM(R7:R11)","v":0},{"$f":"SUM(V7:V11)","v":0},0,""]
["Seules les Cases Blanches",null,{"$f":"$B$5","v":"ST PÈRE / VEZELAY 1"},{"$f":"$B$3","v":"LAVAU 1"},null,{"$f":"IF(E12=\"\",\"\",IF(E12=\"F\",\"G\",IF(E12=\"G\",\"F\",36-E12)))","v":""},null,null,null,null,null,null,null,null,null,"MIGENNES 4",null,"",null,null,0,""]
["sont à remplir",null,"Match 4:  à  - Dimanche 28 Septembre à 14H00",null,null,null,"Classement",null,null,null,null,null,null,null,null,"MIGENNES 4","","",null,null,0,""]
[null,null,{"$f":"$B$1","v":"RAVIERES 4"},{"$f":"$B$5","v":"ST PÈRE / VEZELAY 1"},null,{"$f":"IF(E14=\"\",\"\",IF(E14=\"F\",\"G\",IF(E14=\"G\",\"F\",36-E14)))","v":""},null,null,"Pts","+/-",null,null,null,null,null,"MIGENNES 4",null,"",null,null,0,""," "]
[null,null,{"$f":"$B$2","v":"MAILLY LA VILLE 1"},{"$f":"$B$4","v":"GIVRY 1"},null,{"$f":"IF(E15=\"\",\"\",IF(E15=\"F\",\"G\",IF(E15=\"G\",\"F\",36-E15)))","v":""},1,"RAVIERES 4",0,0,null,null,null,null,null,"MIGENNES 4","","",null,null,0,""]
[null,null,{"$f":"$B$3","v":"LAVAU 1"},{"$f":"$B$6","v":"TOUCY 1"},null,{"$f":"IF(E16=\"\",\"\",IF(E16=\"F\",\"G\",IF(E16=\"G\",\"F\",36-E16)))","v":""},2,"MAILLY LA VILLE 1",0,0,null,null,null,null,null,"MIGENNES 4",null,"",{"$f":"SUM(R12:R16)","v":0},{"$f":"SUM(V12:V16)","v":0},0,""]
[null,null,"Match 5: à  - Dimanche 05 Octobre à 14H00",null,null,null,3,"LAVAU 1",0,0,null,null,null,null,null,"MONETEAU 3","","",null,null,0,""]
[null,null,{"$f":"$B$6","v":"TOUCY 1"},{"$f":"$B$1","v":"RAVIERES 4"},null,{"$f":"IF(E18=\"\",\"\",IF(E18=\"F\",\"G\",IF(E18=\"G\",\"F\",36-E18)))","v":""},4,"GIVRY 1",0,0,null,null,null,null,null,"MONETEAU 3",null,"",null,null,0,""]
[null,null,{"$f":"$B$2","v":"MAILLY LA VILLE 1"},{"$f":"$B$3","v":"LAVAU 1"},null,{"$f":"IF(E19=\"\",\"\",IF(E19=\"F\",\"G\",IF(E19=\"G\",\"F\",36-E19)))","v":""},5,"ST PÈRE / VEZELAY 1",0,0,null,null,null,null,null,"MONETEAU 3","","",null,null,0,""]
[null,null,{"$f":"$B$4","v":"GIVRY 1"},{"$f":"$B$5","v":"ST PÈRE / VEZELAY 1"},null,{"$f":"IF(E20=\"\",\"\",IF(E20=\"F\",\"G\",IF(E20=\"G\",\"F\",36-E20)))","v":""},6,"TOUCY 1",0,0,null,null,null,null,null,"MONETEAU 3",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONETEAU 3","","",{"$f":"SUM(R17:R21)","v":0},{"$f":"SUM(V17:V21)","v":0},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST PÈRE / VEZELAY 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST PÈRE / VEZELAY 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST PÈRE / VEZELAY 1",null,"",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST PÈRE / VEZELAY 1","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ST PÈRE / VEZELAY 1","","",{"$f":"SUM(R22:R26)","v":0},{"$f":"SUM(V22:V26)","v":0},0,""]
[null,"FÉDÉRATION FRANÇAISE DE PÉTANQUE ET JEU PROVENÇAL",null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3","","",null,null,0,""]
[null,"AGRÉÉE PAR LE MINISTÈRE DE LA JEUNESSE ET  DES SPORTS ",null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3",null,"",null,null,0,""]
[null,"TERRITOIRE DE BOURGOGNE ",null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3",null,"",null,null,0,""]
[null,"Championnat Départemental des Clubs 2025 Open Division 5 Groupe C",null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3","","",null,null,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUX 3",null,"",{"$f":"SUM(R27:R31)","v":0},{"$f":"SUM(V27:V31)","v":0},0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U58=0,\"\",IF(U58=19,\"\",U58-(36-U58)))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1) Remplir la liste des Clubs composant le Groupe (Colonne B1 à B14)"]
[]
[null,"2) Le calendrier se fait automatiquement"]
[]
[null,"3) Pour chaque rencontre: mettre uniquemment le score de la premiere équipe (Case Blanche,la rouge sera remplie automatiquement)"]
[]
[null,"4) Le score de l'adversaire se mettra automatiquement"]
[]
[null,"Exemple:"]
[null,"L' équipe 1 Gagne par 32 à 4 : il faut mettre 32 pour le score de L'équipe 1 contre l'équipe 2 (4 sera automatique)"]
[null,null,"Essayez : Tapez 32 ici"]
[]
[null,null,{"$f":"$B$1","v":"RAVIERES 4"},{"$f":"$B$2","v":"MAILLY LA VILLE 1"},null,{"$f":"IF(E306=\"\",\"\",IF(E306=\"F\",\"G\",IF(E306=\"G\",\"F\",36-E306)))","v":""}]
[null,null,{"$f":"$B$3","v":"LAVAU 1"},"Equipe 4",null,{"$f":"IF(E307=\"\",\"\",IF(E307=\"F\",\"G\",IF(E307=\"G\",\"F\",36-E307)))","v":""}]
[]
[null,null,"Essayez : Tapez 17 ici"]
[]
[null,"L' équipe 4 Gagne par 19 à 17 : il faut mettre 17 pour le score de L'équipe 3 contre l'équipe 2 (19  sera automatique)"]
[]
[null,"5) Pour le Forfait : Mettre F si Premiere equipe Forfait sinon mettre G"]
[]
[null,"Exemple:"]
[null,"L' équipe 1 est forfait : il faut mettre un F pour le score de L'équipe 1 contre l'équipe 2 (G est automatique)"]
[null,null,"Essayez : Tapez un F ici"]
[]
[null,null,{"$f":"$B$1","v":"RAVIERES 4"},{"$f":"$B$2","v":"MAILLY LA VILLE 1"},null,{"$f":"IF(E319=\"\",\"\",IF(E319=\"F\",\"G\",IF(E319=\"G\",\"F\",36-E319)))","v":""}]
[null,null,{"$f":"$B$3","v":"LAVAU 1"},"Equipe 4",null,{"$f":"IF(E320=\"\",\"\",IF(E320=\"F\",\"G\",IF(E320=\"G\",\"F\",36-E320)))","v":""}]
[]
[null,null,"Essayez : Tapez un G ici"]
[null,"L' équipe 4 est forfait : il faut mettre un G pour le score de L'équipe 3 contre l'équipe 4 (F est automatique)"]
[]
[]
[null,"En cas de Forfait : le score attribué est 19 à 0"]
[]
[null,"Ne pas oublier d'appuyer sur le bouton Maj Classement sous le Classement"]